GrapeCity.CalcEngine.Functions Namespace > CalcLookupFunction Class > Evaluate Method : Evaluate(Object[]) Method |
The args contains 2 - 3 items: lookup_value, lookup_vector, [result_vector].
Lookup_value is A value that LOOKUP searches for in the first vector. Lookup_value can be a number, text, a logical value, or a name or reference that refers to a value.
Lookup_vector A range that contains only one row or one column. The values in lookup_vector can be text, numbers, or logical values.
Result_vector A range that contains only one row or column. It must be the same size as lookup_vector.
'Declaration Public Overloads Overrides Function Evaluate( _ ByVal args() As System.Object _ ) As System.Object
'Usage Dim instance As CalcLookupFunction Dim args() As System.Object Dim value As System.Object value = instance.Evaluate(args)
public override System.object Evaluate( System.object[] args )
The args contains 2 - 3 items: lookup_value, lookup_vector, [result_vector].
Lookup_value is A value that LOOKUP searches for in the first vector. Lookup_value can be a number, text, a logical value, or a name or reference that refers to a value.
Lookup_vector A range that contains only one row or one column. The values in lookup_vector can be text, numbers, or logical values.
Result_vector A range that contains only one row or column. It must be the same size as lookup_vector.
Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6